Adding Lookup Tables

This section contains an example of adding a lookup table to a process. The example uses the custom process, AbrasiveJet Cut (see Adding a New Process to a Process Group). AbrasiveJet Cut (following Waterjet Cut) will use a lookup table, nozzleType, to store the cost and lifetime for various types of nozzles.

See the following:

For more information on lookup tables, see Working with Lookup Tables in Working with Cost Model Data and Metadata.

Adding a Lookup Table Definition

Before you create the new lookup table, you must create a new lookup table definition (the metadata for the lookup table). Follow these steps:

  1. In the CMWB navigation pane, right-click and select New > Lookup Table Definition.
    The New Lookup Table Definition dialog appears.

  1. Enter the tblAbrasiveJetAbrasiveNozzle in the Name field and click OK. An empty definition table appears in the editing pane.

  2. Add a line to the table, specifying the following column values (double click in a table cell to add a value):

    1. Field Name: nozzleCost

    2. Unit Type Name: Currency

    3. Property Type Name:  double

  3. Add a second line to the table, specifying the following column values:

    1. Field Name: nozzleLife

    2. Unit Type Name: hr (Enter this value by typing, rather than by selecting from the dropdown list.)

    3. Property Type Name:  double

  4. Add a third line to the table, specifying the following column values:

    1. Field Name: nozzleType

    2. Property Type Name:  string

      new_lookup_table.png

  1. Select Save from the File menu, or click save_icon.png in the toolbar, to save your changes.

  2. Click the col_props_icon.png icon to the left of the table name in the editing pane. The column properties and column groups page appears in a new tab in the editing pane. Click Nozzle Type under displayed fields, and click the up arrow, up_arrow.png, to move Nozzle Type to the top.

    column_props.png

  1. Select Save from the File menu, or click save_icon.png in the toolbar, to save your changes.

  2. To incorporate your changes into the cost model, select Publish Cost Model and Digital Factory from the File menu, or click publish_icon.png in the toolbar.